package com.qqb.dao;

import com.qqb.pojo.Officer;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

public interface OfficerDao extends Mapper<Officer> {
    @Select("select Max(oid) from officer_info")
    String getMaxOfficerId();

    @Select("Select code from tb_edu where edu = #{edu}")
    String getEduNum(@Param("edu") String edu);

    @Select("Select code from tb_job where job = #{job}")
    String getJobNum(@Param("job") String job);
}
